/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : localhost:3306
 Source Schema         : pro5books

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 19/08/2021 20:38:48
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for about
-- ----------------------------
DROP TABLE IF EXISTS `about`;
CREATE TABLE `about` (
  `aboutus` varchar(255) NOT NULL DEFAULT '这里是5books网站',
  `donate` varchar(255) NOT NULL DEFAULT 'http://www.baidu.com',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of about
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for back_pic
-- ----------------------------
DROP TABLE IF EXISTS `back_pic`;
CREATE TABLE `back_pic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pic_addr` varchar(255) NOT NULL DEFAULT 'https://file.ituring.com.cn/LargeCover/20120c5528e27aba62b8',
  `up` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of back_pic
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for book
-- ----------------------------
DROP TABLE IF EXISTS `book`;
CREATE TABLE `book` (
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stage` char(11) NOT NULL DEFAULT '0',
  `name` varchar(40) NOT NULL DEFAULT 'NoName',
  `author` varchar(40) NOT NULL DEFAULT '佚名',
  `author_addr` varchar(255) DEFAULT 'http://www.baidu.com' COMMENT '作者的百科链接',
  `price` float NOT NULL DEFAULT '0',
  `uploader` int(11) NOT NULL DEFAULT '0',
  `rate` float NOT NULL DEFAULT '0',
  `rate_addr` varchar(255) NOT NULL DEFAULT 'http://www.baidu.com' COMMENT '豆瓣评分网站的链接',
  `zan` int(11) NOT NULL DEFAULT '0',
  `down_addr` varchar(255) NOT NULL DEFAULT 'http://www.baidu.com',
  `down_num` int(11) NOT NULL DEFAULT '0',
  `intro` varchar(100) NOT NULL DEFAULT '暂无简介',
  `face_addr` varchar(255) NOT NULL DEFAULT 'http://www.baidu.com',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of book
-- ----------------------------
BEGIN;
INSERT INTO `book` VALUES (1, 1, '00300010000', '月亮与六便士', '[英] 威廉·萨默塞特·毛姆', 'https://baike.baidu.com/item/%E5%A8%81%E5%BB%89%C2%B7%E8%90%A8%E9%BB%98%E5%A1%9E%E7%89%B9%C2%B7%E6%AF%9B%E5%A7%86/11019590?fr=aladdin', 1.5, 0, 8.8, 'https://book.douban.com/subject/26954760/', 88, 'https://www.aliyundrive.com/s/KWuSpmSE4K9', 114, '人世漫长得转瞬即逝，有人见尘埃，有人见星辰。', 'https://z3.ax1x.com/2021/08/16/fWSzLT.png', '2021-01-09 00:00:00', '2021-08-19 19:36:32');
INSERT INTO `book` VALUES (1, 2, '00300010000', '恶意', '[日本] 东野圭吾', 'https://baike.baidu.com/item/%E4%B8%9C%E9%87%8E%E5%9C%AD%E5%90%BE/9506697?fr=aladdin', 2.4, 0, 8.7, 'https://book.douban.com/subject/26877752/', 67, 'https://www.aliyundrive.com/s/UoWfAWXHcDJ', 35, '原罪被放大，总有一角照出自己。', 'https://z3.ax1x.com/2021/08/16/fWp7X6.png', '2021-01-09 00:00:00', '2021-08-19 12:36:59');
INSERT INTO `book` VALUES (1, 3, '00300010000', '活着', '余华', 'https://baike.baidu.com/item/%E4%BD%99%E5%8D%8E/6935', 1.1, 0, 9.4, 'https://book.douban.com/subject/4913064/', 49, 'https://www.aliyundrive.com/s/vtJr8joE3bE', 8, '人是为活着本身而活着的，而不是为活着之外的任何事物所活着。', 'https://z3.ax1x.com/2021/08/16/fW9du6.png', '2021-07-22 00:00:00', '2021-08-18 09:34:30');
INSERT INTO `book` VALUES (1, 4, '00300010000', '围城', '钱钟书', 'https://baike.baidu.com/item/%E9%92%B1%E9%94%BA%E4%B9%A6?fromtitle=%E9%92%B1%E9%92%9F%E4%B9%A6&fromid=119811', 0, 0, 9.3, 'https://book.douban.com/subject/11524204/', 56, 'https://www.aliyundrive.com/s/uzowpbG3d3W', 10, '婚姻是一座围城,城外的人想进去,城里的人想出来。', 'https://z3.ax1x.com/2021/08/16/fW9XrV.png', '2021-07-22 00:00:00', '2021-08-19 19:22:29');
INSERT INTO `book` VALUES (1, 12, '00300010000', '边城', '沈从文', 'https://baike.baidu.com/item/%E6%B2%88%E4%BB%8E%E6%96%87', 0, 0, 9.1, 'https://book.douban.com/subject/25843216/', 34, 'https://www.aliyundrive.com/s/BznFMpnwfAE', 555, '这个人也许永远不回来了,也许明天回来。', 'https://z3.ax1x.com/2021/08/16/fWCwzn.png', '2021-07-27 00:00:00', '2021-08-18 00:37:43');
INSERT INTO `book` VALUES (1, 13, '00100010001', 'Java2核心技术（I）', '[美] 霍斯特曼', 'https://horstmann.com/', 2.5, 1, 8.7, 'https://book.douban.com/subject/1781451/', 0, 'https://www.aliyundrive.com/s/a3LeR7ykrEQ', 9, 'Java初学者和Java程序员的必备参考书。', 'https://z3.ax1x.com/2021/08/16/fRJDvq.jpg', '2021-07-27 00:00:00', '2021-08-19 20:37:07');
INSERT INTO `book` VALUES (1, 14, '00100010001', '深入Java虚拟机', '[日]中村成洋', 'https://book.douban.com/subject_search?search_text=%E4%B8%AD%E6%9D%91%E6%88%90%E6%B4%8B', 1.55, 1, 8.3, 'https://book.douban.com/subject/35292560/', 0, 'https://www.aliyundrive.com/s/D16vDUmEc1k', 5, '从入门到进阶阅读学习GC知识，这本可以作为第一本书', 'https://file.ituring.com.cn/LargeCover/20120c5528e27aba62b8', '2021-08-15 22:47:14', '2021-08-19 12:00:11');
INSERT INTO `book` VALUES (1, 15, '00100010001', 'Java2核心技术（II）', '[美] 霍斯特曼', 'https://horstmann.com/', 0, 1, 8.8, 'https://book.douban.com/subject/1231980/', 0, 'https://www.aliyundrive.com/s/79jDkjFwpYf', 1, 'Java 2提供的高级特性及一些相关的组件', 'https://z3.ax1x.com/2021/08/16/fRtBn0.png', '2021-08-16 11:52:16', '2021-08-19 19:38:19');
INSERT INTO `book` VALUES (1, 16, '00100010001', 'Spring 开发指南', '夏昕', '#', 0, 1, 0, '#', 0, 'https://www.aliyundrive.com/s/hXn2PgUQtth', 0, '针对SpringFramework的开发指南', 'https://z3.ax1x.com/2021/08/16/fRaE7V.png', '2021-08-16 11:58:37', '2021-08-18 18:56:50');
INSERT INTO `book` VALUES (1, 17, '00100010002', 'Essential C++中文版', '[美] Stanley B·Lippman', 'https://baike.baidu.com/item/stanley%20b.lippman/9846893', 0, 1, 8.3, 'https://book.douban.com/subject/1215826/', 0, 'https://www.aliyundrive.com/s/coDDxesqpfj', 1, 'C++的函数和结构，以及它们的设计目的和基本原理', 'https://z3.ax1x.com/2021/08/16/fR0yAx.png', '2021-08-16 12:21:52', '2021-08-19 12:02:53');
INSERT INTO `book` VALUES (1, 18, '00100010002', 'C++ Primer Plus英文第六版', 'Stephen Prata', 'https://www.informit.com/authors/bio/efb4e0d2-1782-4f69-8a9e-e208eb58d423', 0, 1, 9.1, 'https://book.douban.com/subject/6971116/', 0, 'https://www.aliyundrive.com/s/4VbTSizjMd7', 1, 'An accessible and easy-to-use self-study C++ guide', 'https://z3.ax1x.com/2021/08/16/fRDclD.png', '2021-08-16 12:35:35', '2021-08-19 12:12:10');
INSERT INTO `book` VALUES (1, 19, '00200000000', '哥德尔、艾舍尔、巴赫', '[美国] 侯世达', 'https://www.mingyantong.com/jianjie/243205', 0, 1, 9.1, 'https://book.douban.com/subject/1291204/', 0, 'https://www.aliyundrive.com/s/HYwp6ZGuiov', 0, '集异璧之大成', 'https://z3.ax1x.com/2021/08/16/fRyMeH.png', '2021-08-16 12:54:53', '2021-08-17 20:41:41');
INSERT INTO `book` VALUES (1, 20, '00100030000', '深入浅出Vue.js', ' 刘博文', 'https://blog.csdn.net/turingbooks/article/details/90709531', 0, 1, 7.8, 'https://book.douban.com/subject/32581281/', 0, 'https://www.aliyundrive.com/s/uh9Y75RGdKc', 0, '从源码层面分析了Vue.js', 'https://z3.ax1x.com/2021/08/16/fR64KS.png', '2021-08-16 13:05:09', '2021-08-17 20:41:42');
INSERT INTO `book` VALUES (1, 21, '00100040000', 'Redis开发与运维', '付磊', '#', 0, 1, 8.9, 'https://book.douban.com/subject/26971561/', 0, '#', 1, '全面讲解Redis基本功能及其应用，为高效开发运维提供了大量实际经验', 'https://z3.ax1x.com/2021/08/16/fRgXBF.png', '2021-08-16 13:15:51', '2021-08-19 12:17:57');
INSERT INTO `book` VALUES (1, 22, '00100040000', '凤凰架构', '周志明', 'https://lk.linkedin.com/in/icyfenix', 1.5, 1, 9.4, 'https://book.douban.com/subject/35492898/', 0, 'https://www.aliyundrive.com/s/pM8rsfaDch8', 28, '从架构视角讲解如何构建大型分布式系统', 'https://z3.ax1x.com/2021/08/16/fR2m4A.png', '2021-08-16 13:20:51', '2021-08-19 17:54:37');
INSERT INTO `book` VALUES (1, 23, '00300010000', '白夜行', '[日] 东野圭吾', 'https://baike.baidu.com/item/%E4%B8%9C%E9%87%8E%E5%9C%AD%E5%90%BE/9506697?fr=aladdin', 0, 1, 9.1, 'https://book.douban.com/subject/10554308/', 0, 'https://www.aliyundrive.com/s/doYumh9aWjJ', 0, '凭借着这份光，我便能把黑夜当成白天。', 'https://z3.ax1x.com/2021/08/16/fRjp6O.png', '2021-08-16 14:34:31', '2021-08-17 20:41:46');
INSERT INTO `book` VALUES (1, 24, '00300010000', '1984', '[英] 乔治·奥威尔', 'https://baike.baidu.com/item/%E4%B9%94%E6%B2%BB%C2%B7%E5%A5%A5%E5%A8%81%E5%B0%94/4122741?fr=aladdin', 0, 1, 9.4, 'https://book.douban.com/subject/4820710/', 0, 'https://www.aliyundrive.com/s/qua5J2pHpLY', 0, '一部杰出的政治寓言小说，也是一部幻想小说。', 'https://z3.ax1x.com/2021/08/16/fRvC80.png', '2021-08-16 14:38:32', '2021-08-17 20:41:47');
INSERT INTO `book` VALUES (1, 25, '00300010000', '海子诗全集', '海子', 'https://baike.baidu.com/item/%E6%B5%B7%E5%AD%90/205722', 0, 1, 9.2, 'https://book.douban.com/subject/3610681/', 0, 'https://www.aliyundrive.com/s/qua5J2pHpLY', 0, '收录迄今为止所有发现的海子文学作品。', 'https://z3.ax1x.com/2021/08/16/fRvILF.png', '2021-08-16 14:42:11', '2021-08-17 20:41:48');
INSERT INTO `book` VALUES (1, 28, '00300010000', '百年孤独', '加夫列尔·加西亚·马尔克斯', 'https://baike.baidu.com/item/%E5%8A%A0%E5%A4%AB%E5%88%97%E5%B0%94%C2%B7%E5%8A%A0%E8%A5%BF%E4%BA%9A%C2%B7%E9%A9%AC%E5%B0%94%E5%85%8B%E6%96%AF/9453532?fromtitle=%E5%8A%A0%E8%A5%BF%E4%BA%9A%C2%B7%E9%A9%AC%E5%B0%94%E5%85%8B%E6%96%AF&fromid=691007', 0, 2, 9.5, 'https://book.douban.com/subject/27107109/', 0, 'https://www.aliyundrive.com/s/BSXArkoSZPV', 0, '“再现拉丁美洲历史社会图景的鸿篇巨著”。', 'https://z3.ax1x.com/2021/08/18/fTBasx.png', '2021-08-18 18:21:23', '2021-08-18 18:54:49');
INSERT INTO `book` VALUES (0, 29, '0', '听听那冷雨', '余光中', 'http://www.baidu.com', 0, 2, 0, 'http://www.baidu.com', 0, 'http://www.baidu.com', 0, '前尘隔海。', 'http://www.baidu.com', '2021-08-18 18:54:07', '2021-08-18 18:54:49');
COMMIT;

-- ----------------------------
-- Table structure for book_cat
-- ----------------------------
DROP TABLE IF EXISTS `book_cat`;
CREATE TABLE `book_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT 'NoName',
  `stage_id` char(11) NOT NULL DEFAULT '00000000000',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `level` tinyint(4) NOT NULL DEFAULT '0',
  `path` varchar(255) DEFAULT 'http://www.baidu.com',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of book_cat
-- ----------------------------
BEGIN;
INSERT INTO `book_cat` VALUES (1, '计算机', '001', 0, 1, NULL, '2021-07-19 00:00:00', '2021-07-19 00:00:00');
INSERT INTO `book_cat` VALUES (2, '科普', '002', 0, 1, NULL, '2021-07-19 00:00:00', '2021-07-19 00:00:00');
INSERT INTO `book_cat` VALUES (3, '文学', '003', 0, 1, NULL, '2021-07-19 00:00:00', '2021-07-19 00:00:00');
INSERT INTO `book_cat` VALUES (4, '其它', '004', 0, 1, NULL, '2021-07-19 00:00:00', '2021-07-19 00:00:00');
INSERT INTO `book_cat` VALUES (5, '编程语言', '0010001', 1, 2, NULL, '2021-07-20 00:00:00', '2021-07-20 00:00:00');
INSERT INTO `book_cat` VALUES (6, '前端', '0010003', 1, 2, NULL, '2021-07-20 00:00:00', '2021-07-20 00:00:00');
INSERT INTO `book_cat` VALUES (7, '后端', '0010004', 1, 2, NULL, '2021-07-20 00:00:00', '2021-07-20 00:00:00');
INSERT INTO `book_cat` VALUES (8, '人工智能', '0010002', 1, 2, NULL, '2021-07-20 00:00:00', '2021-07-20 00:00:00');
INSERT INTO `book_cat` VALUES (9, '软件开发', '0010005', 1, 2, NULL, '2021-07-20 00:00:00', '2021-07-20 00:00:00');
INSERT INTO `book_cat` VALUES (10, '数学', '0020001', 2, 2, NULL, '2021-07-22 00:00:00', '2021-07-22 00:00:00');
INSERT INTO `book_cat` VALUES (11, '物理化学', '0020002', 2, 2, NULL, '2021-07-22 00:00:00', '2021-07-22 00:00:00');
INSERT INTO `book_cat` VALUES (12, 'Java', '00100010001', 5, 3, NULL, '2021-07-26 00:00:00', '2021-07-26 00:00:00');
INSERT INTO `book_cat` VALUES (13, '计算机', '0020003', 2, 2, NULL, '2021-07-31 00:00:00', '2021-07-31 00:00:00');
INSERT INTO `book_cat` VALUES (14, '小说', '0030001', 3, 2, NULL, '2021-07-31 00:00:00', '2021-07-31 00:00:00');
INSERT INTO `book_cat` VALUES (15, '散文诗歌', '0030002', 3, 2, NULL, '2021-07-31 00:00:00', '2021-07-31 00:00:00');
INSERT INTO `book_cat` VALUES (16, '其它', '0030003', 3, 2, NULL, '2021-07-31 00:00:00', '2021-07-31 00:00:00');
INSERT INTO `book_cat` VALUES (17, 'C++', '00100010002', 5, 3, '', '2021-08-16 00:00:00', '2021-08-16 00:00:00');
INSERT INTO `book_cat` VALUES (18, '全部', '00', 0, 1, '', '2021-08-17 00:00:00', '2021-08-17 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for book_cat_admin
-- ----------------------------
DROP TABLE IF EXISTS `book_cat_admin`;
CREATE TABLE `book_cat_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT 'NoName',
  `stage_id` char(11) NOT NULL DEFAULT '00000000000',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `level` tinyint(4) NOT NULL DEFAULT '0',
  `path` varchar(255) DEFAULT 'http://www.baidu.com',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of book_cat_admin
-- ----------------------------
BEGIN;
INSERT INTO `book_cat_admin` VALUES (1, '用户管理', '00000000000', 0, 1, 'http://www.baidu.com', NULL, NULL);
INSERT INTO `book_cat_admin` VALUES (2, '用户列表', '00000000000', 1, 2, 'http://www.baidu.com', NULL, NULL);
INSERT INTO `book_cat_admin` VALUES (3, '图书管理', '00000000000', 0, 1, 'http://www.baidu.com', NULL, NULL);
INSERT INTO `book_cat_admin` VALUES (4, '图书列表', '00000000000', 3, 2, 'http://www.baidu.com', NULL, NULL);
INSERT INTO `book_cat_admin` VALUES (6, '图书分类', '00000000000', 3, 2, 'http://www.baidu.com', NULL, NULL);
INSERT INTO `book_cat_admin` VALUES (7, '权限管理', '00000000000', 0, 1, 'http://www.baidu.com', NULL, NULL);
INSERT INTO `book_cat_admin` VALUES (8, '数据统计', '00000000000', 0, 1, 'http://www.baidu.com', NULL, NULL);
INSERT INTO `book_cat_admin` VALUES (11, '用户列表-新增按钮', '00000000000', 2, 3, 'http://www.baidu.com', NULL, NULL);
INSERT INTO `book_cat_admin` VALUES (12, '用户列表-修改按钮', '00000000000', 2, 3, 'http://www.baidu.com', NULL, NULL);
INSERT INTO `book_cat_admin` VALUES (13, '用户列表-删除按钮', '00000000000', 2, 3, 'http://www.baidu.com', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for book_pic
-- ----------------------------
DROP TABLE IF EXISTS `book_pic`;
CREATE TABLE `book_pic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `book_id` int(11) NOT NULL,
  `book_pic_addr` varchar(255) NOT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of book_pic
-- ----------------------------
BEGIN;
INSERT INTO `book_pic` VALUES (1, 13, 'https://z3.ax1x.com/2021/08/16/fWF6df.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (2, 13, 'https://z3.ax1x.com/2021/08/16/fWFyeP.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (3, 13, 'https://z3.ax1x.com/2021/08/16/fWFco8.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (4, 13, 'https://z3.ax1x.com/2021/08/16/fWFrLt.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (5, 1, 'https://z3.ax1x.com/2021/08/16/fWyoGt.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (6, 1, 'https://z3.ax1x.com/2021/08/16/fWyTRP.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (7, 1, 'https://z3.ax1x.com/2021/08/16/fWy7xf.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (8, 4, 'https://z3.ax1x.com/2021/08/19/fHGAjU.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (9, 4, 'https://z3.ax1x.com/2021/08/19/fHGkcT.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (10, 4, 'https://z3.ax1x.com/2021/08/19/fHGF3V.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (11, 15, 'https://z3.ax1x.com/2021/08/19/fHYHhR.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (12, 15, 'https://z3.ax1x.com/2021/08/19/fHYL1x.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (13, 15, 'https://z3.ax1x.com/2021/08/19/fHYq91.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (14, 15, 'https://z3.ax1x.com/2021/08/19/fHYOc6.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (15, 17, 'https://z3.ax1x.com/2021/08/19/fHN0oQ.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (16, 17, 'https://z3.ax1x.com/2021/08/19/fHNwdg.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (17, 17, 'https://z3.ax1x.com/2021/08/19/fHNdeS.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (18, 18, 'https://z3.ax1x.com/2021/08/19/fHUQXV.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (19, 18, 'https://z3.ax1x.com/2021/08/19/fHUupn.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (20, 18, 'https://z3.ax1x.com/2021/08/19/fHUM60.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (21, 18, 'https://z3.ax1x.com/2021/08/19/fHUKlq.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (22, 22, 'https://z3.ax1x.com/2021/08/19/fHwOgA.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (23, 22, 'https://z3.ax1x.com/2021/08/19/fHwvut.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (24, 22, 'https://z3.ax1x.com/2021/08/19/fHwL3d.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (25, 22, 'https://z3.ax1x.com/2021/08/19/fHwxDP.png', NULL, NULL);
INSERT INTO `book_pic` VALUES (26, 22, 'https://z3.ax1x.com/2021/08/19/fHwXjI.png', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for book_report
-- ----------------------------
DROP TABLE IF EXISTS `book_report`;
CREATE TABLE `book_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `book_id` int(11) NOT NULL,
  `reason` tinyint(4) NOT NULL COMMENT '数字表示举报的类型',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `settled` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of book_report
-- ----------------------------
BEGIN;
INSERT INTO `book_report` VALUES (1, 2, 13, 0, '2021-08-19 17:52:33', '2021-08-19 17:52:33', 0);
INSERT INTO `book_report` VALUES (3, 17, 13, 0, '2021-08-19 17:53:14', '2021-08-19 17:53:14', 0);
INSERT INTO `book_report` VALUES (4, 17, 22, 0, '2021-08-19 17:53:28', '2021-08-19 17:53:28', 0);
INSERT INTO `book_report` VALUES (5, 21, 13, 0, '2021-08-19 19:30:25', '2021-08-19 19:38:15', 1);
INSERT INTO `book_report` VALUES (6, 21, 15, 0, '2021-08-19 19:30:35', '2021-08-19 19:38:21', 1);
COMMIT;

-- ----------------------------
-- Table structure for book_temp
-- ----------------------------
DROP TABLE IF EXISTS `book_temp`;
CREATE TABLE `book_temp` (
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stage` char(11) NOT NULL DEFAULT '00000000000',
  `name` varchar(255) NOT NULL DEFAULT 'NoName',
  `author` varchar(255) NOT NULL DEFAULT '佚名',
  `author_addr` varchar(255) NOT NULL DEFAULT 'http://www.baidu.com',
  `price` float NOT NULL DEFAULT '0',
  `uploader` int(11) NOT NULL DEFAULT '0',
  `rate` float NOT NULL DEFAULT '0',
  `rate_addr` varchar(255) NOT NULL DEFAULT 'http://www.baidu.com',
  `zan` int(11) NOT NULL DEFAULT '0',
  `down_addr` varchar(255) NOT NULL DEFAULT 'http://www.baidu.com',
  `down_num` int(11) NOT NULL DEFAULT '0',
  `intro` varchar(255) NOT NULL DEFAULT '暂无简介',
  `face_addr` varchar(255) NOT NULL DEFAULT 'http://www.baidu.com',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of book_temp
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for msg
-- ----------------------------
DROP TABLE IF EXISTS `msg`;
CREATE TABLE `msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `send` int(11) NOT NULL DEFAULT '0',
  `rece` int(11) NOT NULL DEFAULT '0',
  `message` varchar(255) NOT NULL DEFAULT 'Just for testing',
  `time` datetime NOT NULL,
  `readed` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of msg
-- ----------------------------
BEGIN;
INSERT INTO `msg` VALUES (2, 2, 1, 'ID为 13 、名为 《Java2核心技术（I）》 的书籍被举报，请尽快处理。', '2021-08-19 17:52:33', 1);
INSERT INTO `msg` VALUES (6, 1, 21, '欢迎您，新用户Test01。恭喜您成为本站的第 4 位用户!', '2021-08-19 19:21:54', 1);
INSERT INTO `msg` VALUES (10, 1, 2, '抱歉，您上传的书籍 《毕业》 未通过审核，请您仔细查看该书是否违规。', '2021-08-19 19:37:40', 0);
COMMIT;

-- ----------------------------
-- Table structure for msg_trash
-- ----------------------------
DROP TABLE IF EXISTS `msg_trash`;
CREATE TABLE `msg_trash` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `send` int(11) NOT NULL DEFAULT '0',
  `rece` int(11) NOT NULL DEFAULT '0',
  `message` varchar(255) NOT NULL DEFAULT 'Just for testing',
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of msg_trash
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for payment_info
-- ----------------------------
DROP TABLE IF EXISTS `payment_info`;
CREATE TABLE `payment_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_key` varchar(255) DEFAULT NULL,
  `app_secret` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of payment_info
-- ----------------------------
BEGIN;
INSERT INTO `payment_info` VALUES (1, '72f225401fa243e9', '2ca859da0ec94349a3f786f0bcb57d90');
COMMIT;

-- ----------------------------
-- Table structure for rights
-- ----------------------------
DROP TABLE IF EXISTS `rights`;
CREATE TABLE `rights` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT 'NoName',
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `path` varchar(255) DEFAULT 'http://www.baidu.com',
  `level` tinyint(4) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of rights
-- ----------------------------
BEGIN;
INSERT INTO `rights` VALUES (1, '用户管理', 0, NULL, 1, NULL, NULL);
INSERT INTO `rights` VALUES (2, '用户列表', 1, '/user', 2, NULL, NULL);
INSERT INTO `rights` VALUES (3, '图书管理', 0, NULL, 1, NULL, NULL);
INSERT INTO `rights` VALUES (4, '图书列表', 3, '/book', 2, NULL, NULL);
INSERT INTO `rights` VALUES (5, '图书审核', 3, '/examine', 2, NULL, NULL);
INSERT INTO `rights` VALUES (6, '数据统计', 0, NULL, 1, NULL, NULL);
INSERT INTO `rights` VALUES (7, '用户总数', 6, '/userCounts', 2, NULL, NULL);
INSERT INTO `rights` VALUES (8, '图书总数', 6, '/bookCounts', 2, NULL, NULL);
INSERT INTO `rights` VALUES (9, '图书举报', 3, 'report', 2, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `my_talk` varchar(100) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of test
-- ----------------------------
BEGIN;
INSERT INTO `test` VALUES (1, 'Rick', 'Wubba lubba dub dub', '2019-00-00 00:00:00', '2019-00-00 00:00:00');
INSERT INTO `test` VALUES (2, 'Morty', 'you are a little shit!', '2020-00-00 00:00:00', '2020-00-00 00:00:00');
INSERT INTO `test` VALUES (3, 'Jerry', 'loser', '1200-00-00 00:00:00', '1200-00-00 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(15) NOT NULL,
  `password` char(32) NOT NULL,
  `role` varchar(15) DEFAULT NULL,
  `phone` char(11) DEFAULT '17777777777',
  `head_addr` varchar(255) DEFAULT 'https://z3.ax1x.com/2021/08/18/fIOHSA.png',
  `down_right` tinyint(4) DEFAULT '0',
  `up_right` tinyint(4) DEFAULT '0',
  `ban_right` tinyint(4) DEFAULT '0',
  `ban_time` datetime DEFAULT '2021-01-01 00:00:00',
  `online` tinyint(4) DEFAULT '0',
  `down_num` int(11) DEFAULT '0',
  `diff` char(32) DEFAULT '0',
  `email` varchar(30) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'DAMN4374', '305dc8189de17d002f58f0a4ea0f6785', '管理员', '18593174372', 'https://z3.ax1x.com/2021/08/18/fIONMq.png', 1, 1, 0, '2021-08-30 00:00:00', 0, 0, '0', 'cd4374@outlook.com', '2021-03-02 00:00:00', '2021-03-19 11:06:11');
INSERT INTO `user` VALUES (2, '用户4375', '305dc8189de17d002f58f0a4ea0f6785', '普通用户', '17777777777', 'https://z3.ax1x.com/2021/08/18/fIOHSA.png', 1, 1, 0, '2021-10-01 00:00:00', 0, 0, '0', 'kkkk@4374.com', '2021-07-11 00:00:00', '2021-08-18 18:52:08');
INSERT INTO `user` VALUES (17, '用户4376', '305dc8189de17d002f58f0a4ea0f6785', '普通用户', '15287979549', 'https://z3.ax1x.com/2021/08/18/fIOHSA.png', 1, 0, 0, '2021-01-01 00:00:00', 0, 0, '0', 'xxx@xxxx.com', '2021-08-19 15:13:21', '2021-08-19 15:13:21');
INSERT INTO `user` VALUES (21, 'Test0819', 'f7d8a31840413b8a0dafa950dd00db8e', '普通用户', '18593174372', 'https://z3.ax1x.com/2021/08/18/fIOHSA.png', 1, 1, 0, '2021-01-01 00:00:00', 0, 0, '0', 'aaa@xxxx.com', '2021-08-19 19:21:54', '2021-08-19 19:34:31');
COMMIT;

-- ----------------------------
-- Table structure for user_coll
-- ----------------------------
DROP TABLE IF EXISTS `user_coll`;
CREATE TABLE `user_coll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `book_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_coll
-- ----------------------------
BEGIN;
INSERT INTO `user_coll` VALUES (41, 1, 2, '2021-08-18 10:20:23', '2021-08-18 10:20:23');
INSERT INTO `user_coll` VALUES (42, 13, 2, '2021-08-18 10:20:29', '2021-08-18 10:20:29');
INSERT INTO `user_coll` VALUES (44, 13, 1, '2021-08-18 18:45:58', '2021-08-18 18:45:58');
INSERT INTO `user_coll` VALUES (45, 1, 10, '2021-08-19 13:18:06', '2021-08-19 13:18:06');
INSERT INTO `user_coll` VALUES (47, 22, 1, '2021-08-19 17:54:34', '2021-08-19 17:54:34');
INSERT INTO `user_coll` VALUES (48, 13, 21, '2021-08-19 19:30:21', '2021-08-19 19:30:21');
INSERT INTO `user_coll` VALUES (49, 1, 21, '2021-08-19 19:30:44', '2021-08-19 19:30:44');
INSERT INTO `user_coll` VALUES (50, 22, 21, '2021-08-19 19:30:57', '2021-08-19 19:30:57');
COMMIT;

-- ----------------------------
-- Table structure for user_comm
-- ----------------------------
DROP TABLE IF EXISTS `user_comm`;
CREATE TABLE `user_comm` (
  `book_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comment` varchar(255) DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_comm
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user_oper
-- ----------------------------
DROP TABLE IF EXISTS `user_oper`;
CREATE TABLE `user_oper` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` datetime NOT NULL,
  `operation` tinyint(4) NOT NULL DEFAULT '0',
  `book_id` int(11) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_oper
-- ----------------------------
BEGIN;
INSERT INTO `user_oper` VALUES (1, '2021-08-03 19:06:13', 2, 1, 1);
INSERT INTO `user_oper` VALUES (2, '2021-08-03 19:16:49', 2, 2, 1);
INSERT INTO `user_oper` VALUES (3, '2021-08-03 19:37:28', 2, 1, 1);
INSERT INTO `user_oper` VALUES (4, '2021-08-03 19:45:41', 2, 1, 1);
INSERT INTO `user_oper` VALUES (5, '2021-08-03 19:46:00', 2, 2, 1);
INSERT INTO `user_oper` VALUES (6, '2021-08-03 19:54:31', 2, 4, 1);
INSERT INTO `user_oper` VALUES (7, '2021-08-03 21:36:45', 2, 1, 1);
INSERT INTO `user_oper` VALUES (8, '2021-08-03 22:30:51', 2, 1, 1);
INSERT INTO `user_oper` VALUES (9, '2021-08-03 22:31:22', 2, 1, 1);
INSERT INTO `user_oper` VALUES (10, '2021-08-03 22:31:54', 2, 1, 1);
INSERT INTO `user_oper` VALUES (11, '2021-08-03 23:56:59', 2, 1, 1);
INSERT INTO `user_oper` VALUES (12, '2021-08-04 09:04:26', 2, 1, 1);
INSERT INTO `user_oper` VALUES (13, '2021-08-04 09:07:10', 2, 1, 1);
INSERT INTO `user_oper` VALUES (14, '2021-08-04 14:08:21', 2, 1, 1);
INSERT INTO `user_oper` VALUES (15, '2021-08-04 16:35:01', 2, 1, 1);
INSERT INTO `user_oper` VALUES (16, '2021-08-04 19:31:06', 2, 1, 1);
INSERT INTO `user_oper` VALUES (17, '2021-08-05 14:32:38', 2, 1, 1);
INSERT INTO `user_oper` VALUES (18, '2021-08-05 14:34:29', 2, 1, 1);
INSERT INTO `user_oper` VALUES (19, '2021-08-05 14:41:15', 2, 1, 1);
INSERT INTO `user_oper` VALUES (20, '2021-08-05 14:41:57', 2, 1, 1);
INSERT INTO `user_oper` VALUES (21, '2021-08-05 14:45:48', 2, 1, 1);
INSERT INTO `user_oper` VALUES (22, '2021-08-05 14:46:14', 2, 1, 1);
INSERT INTO `user_oper` VALUES (23, '2021-08-05 14:51:01', 2, 1, 1);
INSERT INTO `user_oper` VALUES (24, '2021-08-05 14:51:50', 2, 1, 1);
INSERT INTO `user_oper` VALUES (25, '2021-08-05 14:59:22', 2, 1, 1);
INSERT INTO `user_oper` VALUES (26, '2021-08-05 16:51:13', 2, 1, 1);
INSERT INTO `user_oper` VALUES (27, '2021-08-05 17:20:02', 2, 1, 1);
INSERT INTO `user_oper` VALUES (28, '2021-08-05 17:41:36', 2, 1, 1);
INSERT INTO `user_oper` VALUES (29, '2021-08-05 17:42:18', 2, 1, 1);
INSERT INTO `user_oper` VALUES (30, '2021-08-07 15:00:30', 2, 1, 1);
INSERT INTO `user_oper` VALUES (31, '2021-08-07 15:01:53', 2, 1, 1);
INSERT INTO `user_oper` VALUES (32, '2021-08-08 13:47:56', 2, 1, 1);
INSERT INTO `user_oper` VALUES (33, '2021-08-08 14:57:44', 2, 1, 1);
INSERT INTO `user_oper` VALUES (34, '2021-08-08 15:01:01', 2, 1, 1);
INSERT INTO `user_oper` VALUES (35, '2021-08-08 15:02:04', 2, 1, 1);
INSERT INTO `user_oper` VALUES (36, '2021-08-08 15:04:03', 2, 1, 1);
INSERT INTO `user_oper` VALUES (37, '2021-08-08 15:05:07', 2, 1, 1);
INSERT INTO `user_oper` VALUES (38, '2021-08-08 15:41:26', 2, 1, 1);
INSERT INTO `user_oper` VALUES (39, '2021-08-08 16:36:20', 2, 13, 1);
INSERT INTO `user_oper` VALUES (40, '2021-08-08 16:37:07', 2, 1, 1);
INSERT INTO `user_oper` VALUES (41, '2021-08-08 20:38:33', 2, 1, 1);
INSERT INTO `user_oper` VALUES (42, '2021-08-08 20:40:02', 2, 1, 1);
INSERT INTO `user_oper` VALUES (43, '2021-08-08 20:41:15', 2, 1, 1);
INSERT INTO `user_oper` VALUES (44, '2021-08-08 21:32:08', 2, 1, 1);
INSERT INTO `user_oper` VALUES (45, '2021-08-09 10:34:23', 2, 1, 1);
INSERT INTO `user_oper` VALUES (46, '2021-08-09 10:34:31', 2, 1, 1);
INSERT INTO `user_oper` VALUES (47, '2021-08-09 10:56:07', 2, 1, 1);
INSERT INTO `user_oper` VALUES (48, '2021-08-10 16:12:50', 2, 1, 1);
INSERT INTO `user_oper` VALUES (49, '2021-08-10 19:29:47', 2, 1, 1);
INSERT INTO `user_oper` VALUES (50, '2021-08-10 23:53:17', 2, 5, 1);
INSERT INTO `user_oper` VALUES (51, '2021-08-10 23:53:24', 2, 1, 1);
INSERT INTO `user_oper` VALUES (52, '2021-08-11 00:05:08', 2, 1, 1);
INSERT INTO `user_oper` VALUES (53, '2021-08-11 15:24:11', 2, 1, 1);
INSERT INTO `user_oper` VALUES (54, '2021-08-11 15:24:20', 2, 1, 1);
INSERT INTO `user_oper` VALUES (55, '2021-08-11 17:17:47', 2, 3, 1);
INSERT INTO `user_oper` VALUES (56, '2021-08-11 22:19:57', 2, 5, 1);
INSERT INTO `user_oper` VALUES (57, '2021-08-13 10:46:25', 2, 1, 1);
INSERT INTO `user_oper` VALUES (58, '2021-08-14 16:35:52', 2, 13, 1);
INSERT INTO `user_oper` VALUES (59, '2021-08-14 18:13:11', 2, 13, 1);
INSERT INTO `user_oper` VALUES (60, '2021-08-15 22:54:04', 2, 14, 1);
INSERT INTO `user_oper` VALUES (61, '2021-08-16 11:31:50', 2, 13, 1);
INSERT INTO `user_oper` VALUES (62, '2021-08-16 15:18:13', 2, 13, 1);
INSERT INTO `user_oper` VALUES (63, '2021-08-16 19:56:42', 2, 1, 1);
INSERT INTO `user_oper` VALUES (64, '2021-08-16 20:05:05', 2, 1, 1);
INSERT INTO `user_oper` VALUES (65, '2021-08-16 22:45:06', 2, 1, 1);
INSERT INTO `user_oper` VALUES (66, '2021-08-16 23:00:01', 2, 1, 1);
INSERT INTO `user_oper` VALUES (67, '2021-08-16 23:01:37', 2, 1, 1);
INSERT INTO `user_oper` VALUES (68, '2021-08-16 23:08:19', 2, 1, 1);
INSERT INTO `user_oper` VALUES (69, '2021-08-16 23:08:50', 2, 1, 1);
INSERT INTO `user_oper` VALUES (70, '2021-08-16 23:09:43', 2, 1, 1);
INSERT INTO `user_oper` VALUES (71, '2021-08-16 23:10:20', 2, 1, 1);
INSERT INTO `user_oper` VALUES (72, '2021-08-16 23:12:38', 2, 1, 1);
INSERT INTO `user_oper` VALUES (73, '2021-08-16 23:12:58', 2, 1, 1);
INSERT INTO `user_oper` VALUES (74, '2021-08-16 23:15:02', 2, 1, 1);
INSERT INTO `user_oper` VALUES (75, '2021-08-16 23:17:53', 2, 1, 1);
INSERT INTO `user_oper` VALUES (76, '2021-08-16 23:19:58', 2, 1, 1);
INSERT INTO `user_oper` VALUES (77, '2021-08-16 23:20:39', 2, 1, 1);
INSERT INTO `user_oper` VALUES (78, '2021-08-16 23:23:03', 2, 1, 1);
INSERT INTO `user_oper` VALUES (79, '2021-08-16 23:41:35', 2, 1, 1);
INSERT INTO `user_oper` VALUES (80, '2021-08-16 23:44:14', 2, 1, 1);
INSERT INTO `user_oper` VALUES (81, '2021-08-16 23:45:20', 2, 1, 1);
INSERT INTO `user_oper` VALUES (82, '2021-08-17 00:08:00', 2, 1, 1);
INSERT INTO `user_oper` VALUES (83, '2021-08-17 01:22:41', 2, 1, 1);
INSERT INTO `user_oper` VALUES (84, '2021-08-17 01:41:44', 2, 1, 1);
INSERT INTO `user_oper` VALUES (85, '2021-08-17 02:15:00', 2, 1, 1);
INSERT INTO `user_oper` VALUES (86, '2021-08-17 02:17:17', 2, 1, 1);
INSERT INTO `user_oper` VALUES (87, '2021-08-17 02:24:09', 2, 1, 1);
INSERT INTO `user_oper` VALUES (88, '2021-08-17 02:26:15', 2, 1, 1);
INSERT INTO `user_oper` VALUES (89, '2021-08-17 02:26:59', 2, 1, 1);
INSERT INTO `user_oper` VALUES (90, '2021-08-17 02:30:05', 2, 1, 1);
INSERT INTO `user_oper` VALUES (91, '2021-08-17 02:31:05', 2, 1, 1);
INSERT INTO `user_oper` VALUES (92, '2021-08-17 02:31:45', 2, 1, 1);
INSERT INTO `user_oper` VALUES (93, '2021-08-17 08:57:20', 2, 1, 1);
INSERT INTO `user_oper` VALUES (94, '2021-08-17 09:55:21', 2, 1, 1);
INSERT INTO `user_oper` VALUES (95, '2021-08-17 09:55:58', 2, 1, 1);
INSERT INTO `user_oper` VALUES (96, '2021-08-17 10:05:08', 2, 1, 1);
INSERT INTO `user_oper` VALUES (97, '2021-08-17 10:10:03', 2, 1, 1);
INSERT INTO `user_oper` VALUES (98, '2021-08-17 10:20:53', 2, 1, 1);
INSERT INTO `user_oper` VALUES (99, '2021-08-17 10:21:04', 2, 1, 1);
INSERT INTO `user_oper` VALUES (100, '2021-08-17 10:54:21', 2, 1, 1);
INSERT INTO `user_oper` VALUES (101, '2021-08-17 10:54:30', 2, 1, 1);
INSERT INTO `user_oper` VALUES (102, '2021-08-17 10:54:50', 2, 1, 1);
INSERT INTO `user_oper` VALUES (103, '2021-08-17 11:30:32', 2, 1, 1);
INSERT INTO `user_oper` VALUES (104, '2021-08-17 11:31:45', 2, 1, 1);
INSERT INTO `user_oper` VALUES (105, '2021-08-17 11:40:27', 2, 1, 1);
INSERT INTO `user_oper` VALUES (106, '2021-08-17 11:50:39', 2, 1, 1);
INSERT INTO `user_oper` VALUES (107, '2021-08-17 11:53:21', 2, 1, 1);
INSERT INTO `user_oper` VALUES (108, '2021-08-17 11:55:17', 2, 1, 1);
INSERT INTO `user_oper` VALUES (109, '2021-08-17 12:01:09', 2, 1, 1);
INSERT INTO `user_oper` VALUES (110, '2021-08-17 12:02:49', 2, 1, 1);
INSERT INTO `user_oper` VALUES (111, '2021-08-17 12:03:47', 2, 1, 1);
INSERT INTO `user_oper` VALUES (112, '2021-08-17 12:11:33', 2, 1, 1);
INSERT INTO `user_oper` VALUES (113, '2021-08-17 12:15:21', 2, 13, 1);
INSERT INTO `user_oper` VALUES (114, '2021-08-17 12:42:45', 2, 1, 1);
INSERT INTO `user_oper` VALUES (115, '2021-08-17 23:40:16', 2, 14, 1);
INSERT INTO `user_oper` VALUES (116, '2021-08-17 23:40:20', 2, 14, 1);
INSERT INTO `user_oper` VALUES (117, '2021-08-17 23:40:46', 2, 1, 1);
INSERT INTO `user_oper` VALUES (118, '2021-08-17 23:41:41', 2, 1, 1);
INSERT INTO `user_oper` VALUES (119, '2021-08-18 00:34:15', 2, 1, 1);
INSERT INTO `user_oper` VALUES (120, '2021-08-18 00:36:57', 2, 1, 1);
INSERT INTO `user_oper` VALUES (121, '2021-08-18 00:37:19', 2, 4, 1);
INSERT INTO `user_oper` VALUES (122, '2021-08-18 00:37:24', 2, 4, 1);
INSERT INTO `user_oper` VALUES (123, '2021-08-18 00:37:43', 2, 12, 1);
INSERT INTO `user_oper` VALUES (124, '2021-08-18 17:51:23', 2, 1, 1);
INSERT INTO `user_oper` VALUES (125, '2021-08-18 18:43:14', 2, 1, 1);
INSERT INTO `user_oper` VALUES (126, '2021-08-18 18:45:12', 2, 4, 1);
INSERT INTO `user_oper` VALUES (127, '2021-08-18 18:51:44', 2, 4, 2);
INSERT INTO `user_oper` VALUES (128, '2021-08-18 19:46:14', 2, 1, 1);
INSERT INTO `user_oper` VALUES (129, '2021-08-19 11:29:49', 2, 22, 1);
INSERT INTO `user_oper` VALUES (130, '2021-08-19 11:30:14', 2, 1, 1);
INSERT INTO `user_oper` VALUES (131, '2021-08-19 11:30:53', 2, 22, 1);
INSERT INTO `user_oper` VALUES (132, '2021-08-19 11:50:26', 2, 4, 1);
INSERT INTO `user_oper` VALUES (133, '2021-08-19 11:55:03', 2, 4, 1);
INSERT INTO `user_oper` VALUES (134, '2021-08-19 11:57:25', 2, 15, 1);
INSERT INTO `user_oper` VALUES (135, '2021-08-19 11:57:37', 2, 14, 1);
INSERT INTO `user_oper` VALUES (136, '2021-08-19 12:00:11', 2, 14, 1);
INSERT INTO `user_oper` VALUES (137, '2021-08-19 12:02:53', 2, 17, 1);
INSERT INTO `user_oper` VALUES (138, '2021-08-19 12:12:10', 2, 18, 1);
INSERT INTO `user_oper` VALUES (139, '2021-08-19 12:17:57', 2, 21, 1);
INSERT INTO `user_oper` VALUES (140, '2021-08-19 12:38:36', 2, 22, 1);
INSERT INTO `user_oper` VALUES (141, '2021-08-19 13:17:59', 2, 1, 10);
INSERT INTO `user_oper` VALUES (142, '2021-08-19 14:00:28', 2, 1, 10);
INSERT INTO `user_oper` VALUES (143, '2021-08-19 17:54:37', 2, 22, 1);
INSERT INTO `user_oper` VALUES (144, '2021-08-19 18:33:01', 2, 1, 1);
INSERT INTO `user_oper` VALUES (145, '2021-08-19 18:39:44', 2, 1, 1);
INSERT INTO `user_oper` VALUES (146, '2021-08-19 18:39:51', 2, 1, 1);
INSERT INTO `user_oper` VALUES (147, '2021-08-19 18:40:06', 2, 1, 1);
INSERT INTO `user_oper` VALUES (148, '2021-08-19 19:22:29', 2, 4, 21);
INSERT INTO `user_oper` VALUES (149, '2021-08-19 19:22:49', 2, 1, 21);
INSERT INTO `user_oper` VALUES (150, '2021-08-19 19:36:32', 2, 1, 21);
INSERT INTO `user_oper` VALUES (151, '2021-08-19 20:37:07', 2, 13, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
